Train Data Raw Summary

Dataset statistics

Number of variables	48
Number of observations	15407
Missing cells	84314
Missing cells (%)	11.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.6 MiB
Average record size in memory	384.0 B

Variable types

CAT	36
NUM	12

Reproduction

Analysis started	2020-06-10 20:12:51.876921
Analysis finished	2020-06-10 20:13:20.033597
Duration	28.16 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`Average Weekly Wage` has a high cardinality: 1966 distinct values	High cardinality
`Claimant Atty Firm Name` has a high cardinality: 453 distinct values	High cardinality
`Claimant Hire Date` has a high cardinality: 4204 distinct values	High cardinality
`Detail Cause` has a high cardinality: 63 distinct values	High cardinality
`Dt Reported to Carrier/TPA` has a high cardinality: 3633 distinct values	High cardinality
`Dt Reported to Employer` has a high cardinality: 4355 distinct values	High cardinality
`Date of Injury/Illness` has a high cardinality: 4430 distinct values	High cardinality
`How Injury Occurred` has a high cardinality: 15344 distinct values	High cardinality
`Injury/Illness City` has a high cardinality: 1340 distinct values	High cardinality
`Injury/Illness Postal` has a high cardinality: 1841 distinct values	High cardinality
`Injury/Illness State` has a high cardinality: 53 distinct values	High cardinality
`Injury/Illness State Code` has a high cardinality: 53 distinct values	High cardinality
`Detail Cause Code` is highly correlated with `Cause Code`	High correlation
`Cause Code` is highly correlated with `Detail Cause Code`	High correlation
`Claimant Gender Code` is highly correlated with `Claimant Gender`	High correlation
`Claimant Gender` is highly correlated with `Claimant Gender Code`	High correlation
`Claimant Marital Status Code` is highly correlated with `Claimant Marital Status`	High correlation
`Claimant Marital Status` is highly correlated with `Claimant Marital Status Code`	High correlation
`Claimant State Code` is highly correlated with `Claimant State`	High correlation
`Claimant State` is highly correlated with `Claimant State Code`	High correlation
`Detail Cause` is highly correlated with `Cause`	High correlation
`Cause` is highly correlated with `Detail Cause`	High correlation
`Domestic vs. Foreign? Code` is highly correlated with `Domestic vs. Foreign?`	High correlation
`Domestic vs. Foreign?` is highly correlated with `Domestic vs. Foreign? Code`	High correlation
`Employment Status Code` is highly correlated with `Employment Status`	High correlation
`Employment Status` is highly correlated with `Employment Status Code`	High correlation
`Injury/Illness State Code` is highly correlated with `Injury/Illness State`	High correlation
`Injury/Illness State` is highly correlated with `Injury/Illness State Code`	High correlation
`Jurisdiction Code` is highly correlated with `Jurisdiction`	High correlation
`Jurisdiction` is highly correlated with `Jurisdiction Code`	High correlation
`Lost Time or Medical Only? Code` is highly correlated with `Lost Time or Medical Only?`	High correlation
`Lost Time or Medical Only?` is highly correlated with `Lost Time or Medical Only? Code`	High correlation
`OSHA Injury Type` is highly correlated with `Nature of Injury/Illness`	High correlation
`Nature of Injury/Illness` is highly correlated with `OSHA Injury Type` and 2 other fields	High correlation
`Type of Loss` is highly correlated with `Nature of Injury/Illness` and 1 other fields	High correlation
`Type of Loss Code` is highly correlated with `Nature of Injury/Illness` and 1 other fields	High correlation
`Average Weekly Wage` has 9535 (61.9%) missing values	Missing
`Claimant Age` has 2163 (14.0%) missing values	Missing
`Claimant Atty Firm Name` has 12410 (80.5%) missing values	Missing
`Claimant Hire Date` has 901 (5.8%) missing values	Missing
`Claimant Marital Status` has 12693 (82.4%) missing values	Missing
`Claimant Marital Status Code` has 12693 (82.4%) missing values	Missing
`Department Code` has 8123 (52.7%) missing values	Missing
`Injury/Illness Postal` has 3684 (23.9%) missing values	Missing
`Number of Dependents` has 14808 (96.1%) missing values	Missing
`Severity Index Code` has 344 (2.2%) missing values	Missing
`Severity Index Code Code` has 344 (2.2%) missing values	Missing
`Reforms_dummy` has 6313 (41.0%) missing values	Missing
`Dependent` is highly skewed (γ1 = 27.90114494)	Skewed
`How Injury Occurred` is uniformly distributed	Uniform
`Obs_ID` has unique values	Unique
`Dependent` has 2689 (17.5%) zeros	Zeros
`Time of Injury/Illness` has 2828 (18.4%) zeros	Zeros

Obs_ID
Categorical

UNIQUE

Distinct count	15407
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Obs_16009	1
Obs_7398	1
Obs_3079	1
Obs_15676	1
Obs_10003	1
Other values (15402)	15402

Common Values
Length

Value	Count	Frequency (%)
Obs_16009	1	< 0.1%
Obs_7398	1	< 0.1%
Obs_3079	1	< 0.1%
Obs_15676	1	< 0.1%
Obs_10003	1	< 0.1%
Obs_2995	1	< 0.1%
Obs_17059	1	< 0.1%
Obs_5274	1	< 0.1%
Obs_2141	1	< 0.1%
Obs_15815	1	< 0.1%
Other values (15397)	15397	99.9%

Length

Max length	9
Median length	8
Mean length	8.407996365
Min length	5

Dependent
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct count	5024
Unique (%)	32.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10285.41370805478
Minimum	0
Maximum	3774290
Zeros	2689
Zeros (%)	17.5%
Memory size	120.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	152
median	446
Q3	1703.5
95-th percentile	51491.9
Maximum	3774290
Range	3774290
Interquartile range (IQR)	1551.5

Descriptive statistics

Standard deviation	54196.59903
Coefficient of variation (CV)	5.269267778
Kurtosis	1591.997702
Mean	10285.41371
Median Absolute Deviation (MAD)	446
Skewness	27.90114494
Sum	158467369
Variance	2937271346

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2689	17.5%
154	42	0.3%
150	32	0.2%
222	28	0.2%
215	27	0.2%
180	27	0.2%
232	24	0.2%
3	24	0.2%
167	23	0.1%
199	23	0.1%
Other values (5014)	12468	80.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2689	17.5%
1	2	< 0.1%
2	2	< 0.1%
3	24	0.2%
4	9	0.1%

Value	Count	Frequency (%)
3774290	1	< 0.1%
1159631	1	< 0.1%
1086522	1	< 0.1%
1083067	1	< 0.1%
1076883	1	< 0.1%

Average Weekly Wage
Categorical

HIGH CARDINALITY
MISSING

Distinct count	1966
Unique (%)	33.5%
Missing	9535
Missing (%)	61.9%
Memory size	120.4 KiB

500	383
320	204
1,000.00	180
600	149
150	126
Other values (1961)	4830

Common Values
Length

Value	Count	Frequency (%)
500	383	2.5%
320	204	1.3%
1,000.00	180	1.2%
600	149	1.0%
150	126	0.8%
100	121	0.8%
400	84	0.5%
1,500.00	70	0.5%
1,200.00	68	0.4%
300	61	0.4%
Other values (1956)	4426	28.7%
(Missing)	9535	61.9%

Length

Max length	8
Median length	3
Mean length	3.984812098
Min length	1

Body Part
Categorical

Distinct count	46
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Finger(s)	1426
Low Back Area	1317
Knee	1236
Other Facial Soft Tissue	1113
Eye(s)	1028
Other values (41)	9287

Common Values
Length

Value	Count	Frequency (%)
Finger(s)	1426	9.3%
Low Back Area	1317	8.5%
Knee	1236	8.0%
Other Facial Soft Tissue	1113	7.2%
Eye(s)	1028	6.7%
Ankle	909	5.9%
Hand	816	5.3%
Shoulder(s)	740	4.8%
Foot	617	4.0%
Lower Leg	568	3.7%
Other values (36)	5637	36.6%

Length

Max length	54
Median length	6
Mean length	10.31161161
Min length	3

Body Part Code
Real number (ℝ_≥0)

Distinct count	46
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	41.06542480690595
Minimum	10
Maximum	90
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	10
5-th percentile	14
Q1	33
median	38
Q3	53
95-th percentile	65
Maximum	90
Range	80
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	17.20610687
Coefficient of variation (CV)	0.4189925455
Kurtosis	0.5526765595
Mean	41.06542481
Median Absolute Deviation (MAD)	15
Skewness	0.4648007928
Sum	632695
Variance	296.0501137

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
36	1426	9.3%
42	1317	8.5%
53	1236	8.0%
18	1113	7.2%
14	1028	6.7%
55	909	5.9%
35	816	5.3%
38	740	4.8%
56	617	4.0%
54	568	3.7%
Other values (36)	5637	36.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	27	0.2%
11	18	0.1%
12	37	0.2%
13	128	0.8%
14	1028	6.7%

Value	Count	Frequency (%)
90	563	3.7%
66	78	0.5%
65	307	2.0%
63	99	0.6%
62	25	0.2%

Cause
Categorical

HIGH CORRELATION

Distinct count	10
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Strain or Injury By	4174
Fall, Slip or Trip Injury	2662
Struck or Injured By	2533
Miscellaneous Causes	2004
Cut, Puncture, Scrape Injured By	1878
Other values (5)	2156

Common Values
Length

Value	Count	Frequency (%)
Strain or Injury By	4174	27.1%
Fall, Slip or Trip Injury	2662	17.3%
Struck or Injured By	2533	16.4%
Miscellaneous Causes	2004	13.0%
Cut, Puncture, Scrape Injured By	1878	12.2%
Striking Against or Stepping on	1009	6.5%
Caught In, Under or Between	558	3.6%
Motor Vehicle	358	2.3%
Burn or Scald - Heat or Cold Exposure	211	1.4%
Rubbed or Abraded By	20	0.1%

Length

Max length	37
Median length	20
Mean length	23.09975985
Min length	13

Cause Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	10
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1497.0662685792172
Minimum	1000
Maximum	1900
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1000
5-th percentile	1200
Q1	1300
median	1500
Q3	1700
95-th percentile	1900
Maximum	1900
Range	900
Interquartile range (IQR)	400

Descriptive statistics

Standard deviation	235.5560533
Coefficient of variation (CV)	0.1573451077
Kurtosis	-0.8318841983
Mean	1497.066269
Median Absolute Deviation (MAD)	200
Skewness	0.114962866
Sum	23065300
Variance	55486.65425

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1500	4174	27.1%
1300	2662	17.3%
1700	2533	16.4%
1900	2004	13.0%
1200	1878	12.2%
1600	1009	6.5%
1100	558	3.6%
1400	358	2.3%
1000	211	1.4%
1800	20	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1000	211	1.4%
1100	558	3.6%
1200	1878	12.2%
1300	2662	17.3%
1400	358	2.3%

Value	Count	Frequency (%)
1900	2004	13.0%
1800	20	0.1%
1700	2533	16.4%
1600	1009	6.5%
1500	4174	27.1%

Claimant Age
Real number (ℝ_≥0)

MISSING

Distinct count	84
Unique (%)	0.6%
Missing	2163
Missing (%)	14.0%
Infinite	0
Infinite (%)	0.0%

Mean	40.286922379945636
Minimum	1.0
Maximum	91.0
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1
5-th percentile	23
Q1	31
median	40
Q3	49
95-th percentile	60
Maximum	91
Range	90
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	11.82069754
Coefficient of variation (CV)	0.2934127713
Kurtosis	-0.5246541589
Mean	40.28692238
Median Absolute Deviation (MAD)	9
Skewness	0.1788198528
Sum	533560
Variance	139.7288904

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
41	436	2.8%
43	382	2.5%
36	378	2.5%
47	377	2.4%
46	376	2.4%
45	369	2.4%
40	369	2.4%
39	366	2.4%
34	364	2.4%
24	361	2.3%
Other values (74)	9466	61.4%
(Missing)	2163	14.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	< 0.1%
2	2	< 0.1%
3	2	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
91	1	< 0.1%
89	1	< 0.1%
85	1	< 0.1%
84	1	< 0.1%
83	2	< 0.1%

Claimant Atty Firm Name
Categorical

HIGH CARDINALITY
MISSING

Distinct count	453
Unique (%)	15.1%
Missing	12410
Missing (%)	80.5%
Memory size	120.4 KiB

TLEVY, STERN & FORD	116
TJ. LEEDS BARROL, IV ATTORNEY AT LAW	58
TLEVY, FORD & WALLACH	51
TLEVY, STERN, & FORD	50
TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO	37
Other values (448)	2685

Common Values
Length

Value	Count	Frequency (%)
TLEVY, STERN & FORD	116	0.8%
TJ. LEEDS BARROL, IV ATTORNEY AT LAW	58	0.4%
TLEVY, FORD & WALLACH	51	0.3%
TLEVY, STERN, & FORD	50	0.3%
TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO	37	0.2%
TLAW OFFICES OF MCNAMARA &	36	0.2%
TMARDER, ESKESEN & NASS	35	0.2%
TKLEIN WAGNER & MORRIS	34	0.2%
TKLEE & WOOLF, LLP	33	0.2%
TLAW OFFICE OF CHRISTINE T. NELSON	33	0.2%
Other values (443)	2514	16.3%
(Missing)	12410	80.5%

Length

Max length	57
Median length	3
Mean length	7.532809762
Min length	3

Claimant Gender
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Male	12375
Female	2950
Uknown	82

Common Values
Length

Value	Count	Frequency (%)
Male	12375	80.3%
Female	2950	19.1%
Uknown	82	0.5%

Length

Max length	6
Median length	4
Mean length	4.39358733
Min length	4

Claimant Gender Code
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

M	12375
F	2950
U	82

Common Values
Length

Value	Count	Frequency (%)
M	12375	80.3%
F	2950	19.1%
U	82	0.5%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Claimant Hire Date
Categorical

HIGH CARDINALITY
MISSING

Distinct count	4204
Unique (%)	29.0%
Missing	901
Missing (%)	5.8%
Memory size	120.4 KiB

1/1/2005	130
2/27/2003	64
1/1/2001	63
1/1/2008	32
7/15/2002	27
Other values (4199)	14190

Common Values
Length

Value	Count	Frequency (%)
1/1/2005	130	0.8%
2/27/2003	64	0.4%
1/1/2001	63	0.4%
1/1/2008	32	0.2%
7/15/2002	27	0.2%
1/7/2013	27	0.2%
1/5/2009	26	0.2%
7/1/2012	25	0.2%
1/1/2013	25	0.2%
1/5/2005	24	0.2%
Other values (4194)	14063	91.3%
(Missing)	901	5.8%

Length

Max length	10
Median length	9
Mean length	8.484195496
Min length	3

Claimant Marital Status
Categorical

HIGH CORRELATION
MISSING

Distinct count	3
Unique (%)	0.1%
Missing	12693
Missing (%)	82.4%
Memory size	120.4 KiB

Unmarried, Single, Widowed, Divorced	1435
Married	1258
Separated	21

Common Values
Length

Value	Count	Frequency (%)
Unmarried, Single, Widowed, Divorced	1435	9.3%
Married	1258	8.2%
Separated	21	0.1%
(Missing)	12693	82.4%

Length

Max length	36
Median length	3
Mean length	6.408385799
Min length	3

Claimant Marital Status Code
Categorical

HIGH CORRELATION
MISSING

Distinct count	3
Unique (%)	0.1%
Missing	12693
Missing (%)	82.4%
Memory size	120.4 KiB

U	1435
M	1258
S	21

Common Values
Length

Value	Count	Frequency (%)
U	1435	9.3%
M	1258	8.2%
S	21	0.1%
(Missing)	12693	82.4%

Length

Max length	3
Median length	3
Mean length	2.647692607
Min length	1

Claimant State
Categorical

HIGH CORRELATION

Distinct count	49
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

California	8912
New York	1121
New Mexico	610
Georgia	532
Texas	517
Other values (44)	3715

Common Values
Length

Value	Count	Frequency (%)
California	8912	57.8%
New York	1121	7.3%
New Mexico	610	4.0%
Georgia	532	3.5%
Texas	517	3.4%
North Carolina	499	3.2%
Louisiana	437	2.8%
New Jersey	341	2.2%
Florida	236	1.5%
Illinois	224	1.5%
Other values (39)	1978	12.8%

Length

Max length	25
Median length	10
Mean length	9.481469462
Min length	4

Claimant State Code
Categorical

HIGH CORRELATION

Distinct count	49
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

CA	8912
NY	1121
NM	610
GA	532
TX	517
Other values (44)	3715

Common Values
Length

Value	Count	Frequency (%)
CA	8912	57.8%
NY	1121	7.3%
NM	610	4.0%
GA	532	3.5%
TX	517	3.4%
NC	499	3.2%
LA	437	2.8%
NJ	341	2.2%
FL	236	1.5%
IL	224	1.5%
Other values (39)	1978	12.8%

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Department Code
Real number (ℝ_≥0)

MISSING

Distinct count	23
Unique (%)	0.3%
Missing	8123
Missing (%)	52.7%
Infinite	0
Infinite (%)	0.0%

Mean	12.119989017023613
Minimum	1.0
Maximum	23.0
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	14
Q3	18
95-th percentile	21
Maximum	23
Range	22
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.014638483
Coefficient of variation (CV)	0.5787660758
Kurtosis	-1.477812356
Mean	12.11998902
Median Absolute Deviation (MAD)	6
Skewness	-0.1316306344
Sum	88282
Variance	49.20515304

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
21	1164	7.6%
17	977	6.3%
8	856	5.6%
3	693	4.5%
6	576	3.7%
2	531	3.4%
14	467	3.0%
18	409	2.7%
11	339	2.2%
1	232	1.5%
Other values (13)	1040	6.8%
(Missing)	8123	52.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	232	1.5%
2	531	3.4%
3	693	4.5%
4	97	0.6%
5	88	0.6%

Value	Count	Frequency (%)
23	52	0.3%
22	121	0.8%
21	1164	7.6%
20	178	1.2%
19	142	0.9%

Detail Cause
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	63
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Strain/Injury by Misc	1577
Strain/Injury by Lifting	1193
Struck by Falling/Flying Object	916
Misc, Other	838
Fall/Slip, Same Level	795
Other values (58)	10088

Common Values
Length

Value	Count	Frequency (%)
Strain/Injury by Misc	1577	10.2%
Strain/Injury by Lifting	1193	7.7%
Struck by Falling/Flying Object	916	5.9%
Misc, Other	838	5.4%
Fall/Slip, Same Level	795	5.2%
Misc, Foreign Body in Eye	778	5.0%
Cut/Puncture/Scrape, Object Lift/Handled	751	4.9%
Strike/Step On, Fixed Object	711	4.6%
Fall/Slip, Misc	631	4.1%
Fall/Slip, Different Level	545	3.5%
Other values (53)	6672	43.3%

Length

Max length	40
Median length	25
Mean length	25.54812747
Min length	9

Detail Cause Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	63
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	54.893749594340235
Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1
5-th percentile	15
Q1	29
median	58
Q3	77
95-th percentile	99
Maximum	99
Range	98
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	26.95204326
Coefficient of variation (CV)	0.4909856488
Kurtosis	-1.189589794
Mean	54.89374959
Median Absolute Deviation (MAD)	25
Skewness	-0.1202439998
Sum	845748
Variance	726.4126359

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
60	1577	10.2%
56	1193	7.7%
75	916	5.9%
99	838	5.4%
29	795	5.2%
87	778	5.0%
17	751	4.9%
68	711	4.6%
31	631	4.1%
25	545	3.5%
Other values (53)	6672	43.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	23	0.1%
2	49	0.3%
3	7	< 0.1%
4	31	0.2%
5	28	0.2%

Value	Count	Frequency (%)
99	838	5.4%
97	350	2.3%
94	20	0.1%
90	232	1.5%
89	3	< 0.1%

Domestic vs. Foreign?
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Domestic	15190
Foreign	217

Common Values
Length

Value	Count	Frequency (%)
Domestic	15190	98.6%
Foreign	217	1.4%

Length

Max length	8
Median length	8
Mean length	7.985915493
Min length	7

Domestic vs. Foreign? Code
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

D	15190
F	217

Common Values
Length

Value	Count	Frequency (%)
D	15190	98.6%
F	217	1.4%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Dt Reported to Carrier/TPA
Categorical

HIGH CARDINALITY

Distinct count	3633
Unique (%)	23.6%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

8/31/2011	15
7/24/2012	15
6/17/2013	15
3/26/2012	14
6/27/2014	14
Other values (3628)	15334

Common Values
Length

Value	Count	Frequency (%)
8/31/2011	15	0.1%
7/24/2012	15	0.1%
6/17/2013	15	0.1%
3/26/2012	14	0.1%
6/27/2014	14	0.1%
11/22/2011	14	0.1%
12/10/2002	14	0.1%
8/26/2011	14	0.1%
4/5/2004	13	0.1%
11/14/2002	13	0.1%
Other values (3623)	15266	99.1%

Length

Max length	10
Median length	9
Mean length	8.944246122
Min length	8

Dt Reported to Employer
Categorical

HIGH CARDINALITY

Distinct count	4355
Unique (%)	28.5%
Missing	146
Missing (%)	0.9%
Memory size	120.4 KiB

8/15/2005	15
8/30/2011	14
6/5/2013	13
9/20/2011	13
9/13/2011	13
Other values (4350)	15193

Common Values
Length

Value	Count	Frequency (%)
8/15/2005	15	0.1%
8/30/2011	14	0.1%
6/5/2013	13	0.1%
9/20/2011	13	0.1%
9/13/2011	13	0.1%
7/31/2013	12	0.1%
7/24/2002	12	0.1%
8/2/2012	12	0.1%
3/19/2009	12	0.1%
4/20/2011	12	0.1%
Other values (4345)	15133	98.2%
(Missing)	146	0.9%

Length

Max length	10
Median length	9
Mean length	8.882196404
Min length	3

Employment Status
Categorical

HIGH CORRELATION

Distinct count	12
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Unknown/Other	12564
Full-Time	2440
Seasonal	190
Part-Time	97
Piece Worker	66
Other values (7)	50

Common Values
Length

Value	Count	Frequency (%)
Unknown/Other	12564	81.5%
Full-Time	2440	15.8%
Seasonal	190	1.2%
Part-Time	97	0.6%
Piece Worker	66	0.4%
On Strike	18	0.1%
Apprenticeship Full-Time	14	0.1%
Disabled	9	0.1%
Retired	3	< 0.1%
Volunteer	2	< 0.1%
Other values (2)	4	< 0.1%

Length

Max length	24
Median length	13
Mean length	12.27740637
Min length	7

Employment Status Code
Categorical

HIGH CORRELATION

Distinct count	12
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

7	12564
1	2440
8	190
2	97
C	66
Other values (7)	50

Common Values
Length

Value	Count	Frequency (%)
7	12564	81.5%
1	2440	15.8%
8	190	1.2%
2	97	0.6%
C	66	0.4%
4	18	0.1%
A	14	0.1%
5	9	0.1%
6	3	< 0.1%
9	2	< 0.1%
Other values (2)	4	< 0.1%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Date of Injury/Illness
Categorical

HIGH CARDINALITY

Distinct count	4430
Unique (%)	28.8%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

10/3/2005	25
6/21/2005	19
6/22/2005	18
6/20/2013	16
9/30/2011	15
Other values (4425)	15314

Common Values
Length

Value	Count	Frequency (%)
10/3/2005	25	0.2%
6/21/2005	19	0.1%
6/22/2005	18	0.1%
6/20/2013	16	0.1%
9/30/2011	15	0.1%
8/30/2011	14	0.1%
4/20/2011	13	0.1%
10/3/2003	13	0.1%
5/6/2009	13	0.1%
2/23/2001	13	0.1%
Other values (4420)	15248	99.0%

Length

Max length	10
Median length	9
Mean length	8.932563121
Min length	8

Handling Office Name
Categorical

Distinct count	28
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

LOS ANGELE	7112
SACRAMENTO	1884
DALLAS WC	1345
NEW JERSEY	861
LONG ISLAN	534
Other values (23)	3671

Common Values
Length

Value	Count	Frequency (%)
LOS ANGELE	7112	46.2%
SACRAMENTO	1884	12.2%
DALLAS WC	1345	8.7%
NEW JERSEY	861	5.6%
LONG ISLAN	534	3.5%
WC SOUTHEA	522	3.4%
CHARLOTTE	515	3.3%
IN-STATE A	353	2.3%
ATLANTA	297	1.9%
ILLINOIS	281	1.8%
Other values (18)	1703	11.1%

Length

Max length	10
Median length	10
Mean length	9.69942234
Min length	6

How Injury Occurred
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	15344
Unique (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

WORKING IN WOODED TALL GRASS AREA - EE WAS BITTEN BY DEER TI	17
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN	7
UNKNOWN	7
EMPLOYEE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON S	7
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET.	5
Other values (15339)	15364

Common Values
Length

Value	Count	Frequency (%)
WORKING IN WOODED TALL GRASS AREA - EE WAS BITTEN BY DEER TI	17	0.1%
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN	7	< 0.1%
UNKNOWN	7	< 0.1%
EMPLOYEE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON S	7	< 0.1%
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET.	5	< 0.1%
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET	4	< 0.1%
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET - P	3	< 0.1%
COMPLAINED OF EYE IRRITATION UPON INSERTION OF CONTACT LENS.	2	< 0.1%
WHILE EE WORKING ON SET LOCATION HE DEVELOPED MULTIPLE PUSTU	2	< 0.1%
EE EXPERIENCED A CHEMICAL REACTION TO THE FUMES WHEN HE WAS	2	< 0.1%
Other values (15334)	15351	99.6%

Length

Max length	60
Median length	60
Mean length	57.90601675
Min length	7

Injury/Illness City
Categorical

HIGH CARDINALITY

Distinct count	1340
Unique (%)	8.7%
Missing	1
Missing (%)	< 0.1%
Memory size	120.4 KiB

LOS ANGELES	2294
UNKNOWN	1538
BURBANK	1506
NEW ORLEANS	610
NEW YORK	393
Other values (1335)	9065

Common Values
Length

Value	Count	Frequency (%)
LOS ANGELES	2294	14.9%
UNKNOWN	1538	10.0%
BURBANK	1506	9.8%
NEW ORLEANS	610	4.0%
NEW YORK	393	2.6%
BROOKLYN	388	2.5%
WILMINGTON	328	2.1%
CULVER CITY	298	1.9%
AUSTIN	261	1.7%
ATLANTA	222	1.4%
Other values (1330)	7568	49.1%

Length

Max length	19
Median length	8
Mean length	9.119101707
Min length	1

Injury/Illness Postal
Categorical

HIGH CARDINALITY
MISSING

Distinct count	1841
Unique (%)	15.7%
Missing	3684
Missing (%)	23.9%
Memory size	120.4 KiB

91502	1369
95816	406
90038	303
90001	222
90028	219
Other values (1836)	9204

Common Values
Length

Value	Count	Frequency (%)
91502	1369	8.9%
95816	406	2.6%
90038	303	2.0%
90001	222	1.4%
90028	219	1.4%
91505	199	1.3%
90232	171	1.1%
91504	167	1.1%
91608	158	1.0%
91521	127	0.8%
Other values (1831)	8382	54.4%
(Missing)	3684	23.9%

Length

Max length	9
Median length	5
Mean length	4.513467904
Min length	3

Injury/Illness State
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	53
Unique (%)	0.3%
Missing	12
Missing (%)	0.1%
Memory size	120.4 KiB

California	8019
New York	1356
Louisiana	1132
Georgia	654
North Carolina	583
Other values (48)	3651

Common Values
Length

Value	Count	Frequency (%)
California	8019	52.0%
New York	1356	8.8%
Louisiana	1132	7.3%
Georgia	654	4.2%
North Carolina	583	3.8%
Texas	403	2.6%
New Mexico	383	2.5%
Pennsylvania	311	2.0%
Michigan	274	1.8%
Utah	263	1.7%
Other values (43)	2017	13.1%

Length

Max length	25
Median length	10
Mean length	9.506003765
Min length	3

Injury/Illness State Code
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	53
Unique (%)	0.3%
Missing	12
Missing (%)	0.1%
Memory size	120.4 KiB

CA	8019
NY	1356
LA	1132
GA	654
NC	583
Other values (48)	3651

Common Values
Length

Value	Count	Frequency (%)
CA	8019	52.0%
NY	1356	8.8%
LA	1132	7.3%
GA	654	4.2%
NC	583	3.8%
TX	403	2.6%
NM	383	2.5%
PA	311	2.0%
MI	274	1.8%
UT	263	1.7%
Other values (43)	2017	13.1%

Length

Max length	3
Median length	2
Mean length	2.000778867
Min length	2

Jurisdiction
Categorical

HIGH CORRELATION

Distinct count	47
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

California	9094
New York	1525
Louisiana	851
Georgia	565
North Carolina	535
Other values (42)	2837

Common Values
Length

Value	Count	Frequency (%)
California	9094	59.0%
New York	1525	9.9%
Louisiana	851	5.5%
Georgia	565	3.7%
North Carolina	535	3.5%
Texas	353	2.3%
New Mexico	332	2.2%
Pennsylvania	244	1.6%
Illinois	241	1.6%
Utah	236	1.5%
Other values (37)	1431	9.3%

Length

Max length	20
Median length	10
Mean length	9.506523009
Min length	4

Jurisdiction Code
Categorical

HIGH CORRELATION

Distinct count	47
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

CA	9094
NY	1525
LA	851
GA	565
NC	535
Other values (42)	2837

Common Values
Length

Value	Count	Frequency (%)
CA	9094	59.0%
NY	1525	9.9%
LA	851	5.5%
GA	565	3.7%
NC	535	3.5%
TX	353	2.3%
NM	332	2.2%
PA	244	1.6%
IL	241	1.6%
UT	236	1.5%
Other values (37)	1431	9.3%

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Lost Time or Medical Only?
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	11
Missing (%)	0.1%
Memory size	120.4 KiB

Medical Only	11684
Lost Time	3712

Common Values
Length

Value	Count	Frequency (%)
Medical Only	11684	75.8%
Lost Time	3712	24.1%
(Missing)	11	0.1%

Length

Max length	12
Median length	12
Mean length	11.27078601
Min length	3

Lost Time or Medical Only? Code
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	11
Missing (%)	0.1%
Memory size	120.4 KiB

MO	11684
LT	3712

Common Values
Length

Value	Count	Frequency (%)
MO	11684	75.8%
LT	3712	24.1%
(Missing)	11	0.1%

Length

Max length	3
Median length	2
Mean length	2.000713961
Min length	2

Nature of Injury/Illness
Categorical

HIGH CORRELATION

Distinct count	45
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	120.4 KiB

Strain	3583
Laceration	2418
Specific Injury - All Other	2221
Contusion	1610
Sprain	1025
Other values (40)	4550

Common Values
Length

Value	Count	Frequency (%)
Strain	3583	23.3%
Laceration	2418	15.7%
Specific Injury - All Other	2221	14.4%
Contusion	1610	10.4%
Sprain	1025	6.7%
Puncture	785	5.1%
Foreign Body	759	4.9%
Inflammation	670	4.3%
Fracture	570	3.7%
Infection	200	1.3%
Other values (35)	1566	10.2%

Length

Max length	59
Median length	9
Mean length	11.81729084
Min length	4

Nature of Injury/Illness Code
Real number (ℝ_≥0)

Distinct count	45
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	41.65898617511521
Minimum	1
Maximum	91
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	36
median	43
Q3	52
95-th percentile	59
Maximum	91
Range	90
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	17.19567328
Coefficient of variation (CV)	0.4127722458
Kurtosis	0.08174911361
Mean	41.65898618
Median Absolute Deviation (MAD)	9
Skewness	-0.4530364745
Sum	641840
Variance	295.6911796

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
52	3583	23.3%
40	2418	15.7%
59	2221	14.4%
10	1610	10.4%
49	1025	6.7%
43	785	5.1%
25	759	4.9%
37	670	4.3%
28	570	3.7%
36	200	1.3%
Other values (35)	1566	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	72	0.5%
2	11	0.1%
3	4	< 0.1%
4	177	1.1%
7	72	0.5%

Value	Count	Frequency (%)
91	65	0.4%
90	120	0.8%
80	56	0.4%
78	15	0.1%
77	14	0.1%

Number of Dependents
Real number (ℝ_≥0)

MISSING

Distinct count	9
Unique (%)	1.5%
Missing	14808
Missing (%)	96.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.9131886477462436
Minimum	1.0
Maximum	18.0
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	4
Maximum	18
Range	17
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.334821653
Coefficient of variation (CV)	0.6976947384
Kurtosis	38.79484103
Mean	1.913188648
Median Absolute Deviation (MAD)	1
Skewness	4.345641318
Sum	1146
Variance	1.781748846

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	281	1.8%
2	187	1.2%
3	84	0.5%
4	29	0.2%
5	8	0.1%
6	4	< 0.1%
9	3	< 0.1%
7	2	< 0.1%
18	1	< 0.1%
(Missing)	14808	96.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	281	1.8%
2	187	1.2%
3	84	0.5%
4	29	0.2%
5	8	0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
9	3	< 0.1%
7	2	< 0.1%
6	4	< 0.1%
5	8	0.1%

OSHA Injury Type
Categorical

HIGH CORRELATION

Distinct count	6
Unique (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	120.4 KiB

Injury	15128
Skin disorder	156
Respiratory condition	60
Poisoning	27
Hearing loss	26

Common Values
Length

Value	Count	Frequency (%)
Injury	15128	98.2%
Skin disorder	156	1.0%
Respiratory condition	60	0.4%
Poisoning	27	0.2%
Hearing loss	26	0.2%
All other illnesses	8	0.1%
(Missing)	2	< 0.1%

Length

Max length	21
Median length	6
Mean length	6.151035244
Min length	3

OSHA Injury Type Code
Real number (ℝ_≥0)

Distinct count	6
Unique (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.0325219084712756
Minimum	1.0
Maximum	6.0
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	6
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2835746844
Coefficient of variation (CV)	0.2746427772
Kurtosis	142.0491387
Mean	1.032521908
Median Absolute Deviation (MAD)	0
Skewness	11.12582568
Sum	15906
Variance	0.08041460165

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	15128	98.2%
2	156	1.0%
3	60	0.4%
4	27	0.2%
5	26	0.2%
6	8	0.1%
(Missing)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15128	98.2%
2	156	1.0%
3	60	0.4%
4	27	0.2%
5	26	0.2%

Value	Count	Frequency (%)
6	8	0.1%
5	26	0.2%
4	27	0.2%
3	60	0.4%
2	156	1.0%

Severity Index Code
Categorical

MISSING

Distinct count	10
Unique (%)	0.1%
Missing	344
Missing (%)	2.2%
Memory size	120.4 KiB

No Serious Injury Indicated	15000
Fatality	19
Fractured Bone(s)	15
Back Injury involving Surgery/Extended Disability	10
Involves AIDS, Herpes, TSS, Cancer, Other Diseases	5
Other values (5)	14

Common Values
Length

Value	Count	Frequency (%)
No Serious Injury Indicated	15000	97.4%
Fatality	19	0.1%
Fractured Bone(s)	15	0.1%
Back Injury involving Surgery/Extended Disability	10	0.1%
Involves AIDS, Herpes, TSS, Cancer, Other Diseases	5	< 0.1%
Heart Attack or Cardio-Vascular Accident	4	< 0.1%
Serious Head Injury	4	< 0.1%
Serious Burns	2	< 0.1%
Minor Amputation	2	< 0.1%
Major Amputation	2	< 0.1%
(Missing)	344	2.2%

Length

Max length	50
Median length	27
Mean length	26.44934121
Min length	3

Severity Index Code Code
Real number (ℝ_≥0)

MISSING

Distinct count	10
Unique (%)	0.1%
Missing	344
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%

Mean	9.983270264887473
Minimum	1.0
Maximum	15.0
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	15
Range	14
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3783217512
Coefficient of variation (CV)	0.03789557341
Kurtosis	459.3414733
Mean	9.983270265
Median Absolute Deviation (MAD)	0
Skewness	-19.43872707
Sum	150378
Variance	0.1431273474

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	15000	97.4%
1	19	0.1%
9	15	0.1%
7	10	0.1%
14	5	< 0.1%
6	4	< 0.1%
4	4	< 0.1%
15	2	< 0.1%
2	2	< 0.1%
5	2	< 0.1%
(Missing)	344	2.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	19	0.1%
2	2	< 0.1%
4	4	< 0.1%
5	2	< 0.1%
6	4	< 0.1%

Value	Count	Frequency (%)
15	2	< 0.1%
14	5	< 0.1%
10	15000	97.4%
9	15	0.1%
7	10	0.1%

Time of Injury/Illness
Real number (ℝ_≥0)

ZEROS

Distinct count	581
Unique (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1010.9847471928344
Minimum	0
Maximum	2359
Zeros	2828
Zeros (%)	18.4%
Memory size	120.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	615
median	1035
Q3	1510
95-th percentile	2025
Maximum	2359
Range	2359
Interquartile range (IQR)	895

Descriptive statistics

Standard deviation	660.7386831
Coefficient of variation (CV)	0.6535594973
Kurtosis	-0.9523935227
Mean	1010.984747
Median Absolute Deviation (MAD)	465
Skewness	-0.1933581149
Sum	15576242
Variance	436575.6074

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2828	18.4%
1000	661	4.3%
1400	538	3.5%
1100	530	3.4%
1500	470	3.1%
900	407	2.6%
1600	401	2.6%
1300	386	2.5%
800	384	2.5%
1700	300	1.9%
Other values (571)	8502	55.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2828	18.4%
1	2	< 0.1%
2	1	< 0.1%
4	1	< 0.1%
5	15	0.1%

Value	Count	Frequency (%)
2359	2	< 0.1%
2355	7	< 0.1%
2353	1	< 0.1%
2350	7	< 0.1%
2348	1	< 0.1%

Type of Loss
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	53
Missing (%)	0.3%
Memory size	120.4 KiB

Specific Injury	15195
Cumulative Trauma	159

Common Values
Length

Value	Count	Frequency (%)
Specific Injury	15195	98.6%
Cumulative Trauma	159	1.0%
(Missing)	53	0.3%

Length

Max length	17
Median length	15
Mean length	14.97936003
Min length	3

Type of Loss Code
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	53
Missing (%)	0.3%
Memory size	120.4 KiB

3	15195
1	159

Common Values
Length

Value	Count	Frequency (%)
3	15195	98.6%
1	159	1.0%
(Missing)	53	0.3%

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Policy Year
Real number (ℝ_≥0)

Distinct count	15
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2007.6086194586876
Minimum	2000
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Memory size	120.4 KiB

Quantile statistics

Minimum	2000
5-th percentile	2000
Q1	2004
median	2008
Q3	2011
95-th percentile	2014
Maximum	2014
Range	14
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.268828711
Coefficient of variation (CV)	0.002126325156
Kurtosis	-1.203913341
Mean	2007.608619
Median Absolute Deviation (MAD)	4
Skewness	-0.1645031735
Sum	30931226
Variance	18.22289857

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2011	1440	9.3%
2013	1325	8.6%
2012	1196	7.8%
2005	1141	7.4%
2014	1123	7.3%
2010	1095	7.1%
2004	1029	6.7%
2008	969	6.3%
2002	950	6.2%
2009	932	6.0%
Other values (5)	4207	27.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2000	778	5.0%
2001	697	4.5%
2002	950	6.2%
2003	908	5.9%
2004	1029	6.7%

Value	Count	Frequency (%)
2014	1123	7.3%
2013	1325	8.6%
2012	1196	7.8%
2011	1440	9.3%
2010	1095	7.1%

Reforms_dummy
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	6313
Missing (%)	41.0%
Memory size	120.4 KiB

California Refom 1	4983
California Refom 0	3022
California Reform 2	1089

Common Values
Length

Value	Count	Frequency (%)
California Refom 1	4983	32.3%
California Refom 0	3022	19.6%
California Reform 2	1089	7.1%
(Missing)	6313	41.0%

Length

Max length	19
Median length	18
Mean length	11.92444993
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Obs_ID	Dependent	Average Weekly Wage	Body Part	Body Part Code	Cause	Cause Code	Claimant Age	Claimant Atty Firm Name	Claimant Gender	Claimant Gender Code	Claimant Hire Date	Claimant Marital Status	Claimant Marital Status Code	Claimant State	Claimant State Code	Department Code	Detail Cause	Detail Cause Code	Domestic vs. Foreign?	Domestic vs. Foreign? Code	Dt Reported to Carrier/TPA	Dt Reported to Employer	Employment Status	Employment Status Code	Date of Injury/Illness	Handling Office Name	How Injury Occurred	Injury/Illness City	Injury/Illness Postal	Injury/Illness State	Injury/Illness State Code	Jurisdiction	Jurisdiction Code	Lost Time or Medical Only?	Lost Time or Medical Only? Code	Nature of Injury/Illness	Nature of Injury/Illness Code	Number of Dependents	OSHA Injury Type	OSHA Injury Type Code	Severity Index Code	Severity Index Code Code	Time of Injury/Illness	Type of Loss	Type of Loss Code	Policy Year	Reforms_dummy
0	Obs_1	98679	500	Pelvis	46	Struck or Injured By	1700	21.0	NaN	Female	F	4/3/2001	NaN	NaN	California	CA	NaN	Struck by Falling/Flying Object	75	Domestic	D	4/17/2001	4/13/2001	Full-Time	1	4/13/2001	LOS ANGELE	GOING DOWN SKI HILL ON AN AIR MATTRESS AS PART OF A SKIT,	PORTLAND	97201	Oregon	OR	California	CA	Lost Time	LT	Fracture	28	NaN	Injury	1.0	Fractured Bone(s)	9.0	1430	Specific Injury	3.0	2001	California Refom 0
1	Obs_2	55727	1,037.00	Low Back Area	42	Strain or Injury By	1500	NaN	NaN	Male	M	5/15/2001	NaN	NaN	California	CA	NaN	Strain/Injury by Lifting	56	Domestic	D	5/25/2001	5/24/2001	Full-Time	1	5/22/2001	IN-STATE A	REPETITIVE LIFTING OF CABLE, EE STRAINED LOWER BACK	PEARL HARBOR	NaN	Hawaii	HI	Hawaii	HI	Lost Time	LT	Strain	52	1.0	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2001	NaN
2	Obs_3	185833	929	Low Back Area	42	Strain or Injury By	1500	63.0	TROBINSON & CHUR ATTORNEYS AT LAW	Male	M	5/15/2001	Married	M	Hawaii	HI	NaN	Strain/Injury by Carrying	55	Domestic	D	5/31/2001	5/22/2001	Unknown/Other	7	5/22/2001	IN-STATE A	STRAINED LOW BACK MOVING A PALM TREE WITH CO-WORKER	PEARL HARBOR	96860	Hawaii	HI	Hawaii	HI	Lost Time	LT	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2001	NaN
3	Obs_4	98615	1,226.00	Multiple Body Parts	90	Strain or Injury By	1500	49.0	IBARRY STEVENS;;M;;	Male	M	NaN	NaN	NaN	Idaho	ID	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	12/31/2003	12/23/2003	Unknown/Other	7	3/31/2002	LOS ANGELE	EE CLAIMS: CT 1973 -/02 TO BOTH SHOULDERS - SPINE - AND EAR	BURBANK	91502	California	CA	California	CA	Lost Time	LT	Specific Injury - All Other	59	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2002	California Refom 0
4	Obs_5	51396	NaN	Other Facial Soft Tissue	18	Miscellaneous Causes	1900	51.0	IBARRY STEVENS;;M;;	Male	M	NaN	NaN	NaN	Idaho	ID	NaN	Misc, No Physical Cause	90	Domestic	D	2/18/2004	2/17/2004	Unknown/Other	7	8/1/2003	LOS ANGELE	EMPLOYEE CLAIMS: CT 11/16/93 -8/1/03; PHYSICAL STRESS AND ST	BURBANK	91502	California	CA	California	CA	Lost Time	LT	Specific Injury - All Other	59	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2003	California Refom 0
5	Obs_6	4079	NaN	Multiple Upper Extremities	30	Strain or Injury By	1500	55.0	IWAX & WAX;;A;;	Male	M	NaN	NaN	NaN	California	CA	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	3/19/2004	3/19/2004	Unknown/Other	7	12/31/2002	LOS ANGELE	EE CLAIMS: CT 1980 -NOV 2003 TO NECK - BACK - BOTH UPPER EXT	BURBANK	91502	California	CA	California	CA	Lost Time	LT	Carpal Tunnel Syndrome	78	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Cumulative Trauma	1.0	2002	California Refom 0
6	Obs_8	1909	1,129.00	Low Back Area	42	Strain or Injury By	1500	49.0	TCRAIG RICHLIN	Male	M	1/22/2000	NaN	NaN	California	CA	NaN	Strain/Injury by Misc	60	Domestic	D	6/10/2004	6/7/2004	Unknown/Other	7	12/31/2000	LOS ANGELE	EE CLAIMS CT 09/25/00 09/25/01 TO LEFT LOWER EXTREMITY AND B	UNKNOWN	NaN	California	CA	California	CA	Lost Time	LT	Specific Injury - All Other	59	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2000	California Refom 0
7	Obs_9	6687	NaN	Low Back Area	42	Strain or Injury By	1500	36.0	NaN	Male	M	NaN	NaN	NaN	California	CA	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	7/8/2004	6/28/2004	Unknown/Other	7	2/21/2001	LOS ANGELE	EE CLAIMS REPETITIVE BACK INJURY CT 8/1/99-11/03 FROM REPETI	MISSION HILLS	91345	California	CA	California	CA	Lost Time	LT	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2001	California Refom 0
8	Obs_10	5352	NaN	Low Back Area	42	Strain or Injury By	1500	45.0	NaN	Male	M	NaN	NaN	NaN	California	CA	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	7/8/2004	7/2/2004	Unknown/Other	7	4/23/2003	LOS ANGELE	EE CLAIMS; CT 4/23/02-4/23/03 TO SPINE. BILATERAL UPPER EXTR	BURBANK	91504	California	CA	California	CA	Lost Time	LT	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2003	California Refom 0
9	Obs_11	6324	1,000.00	Lower Leg	54	Strain or Injury By	1500	45.0	NaN	Male	M	10/3/2002	NaN	NaN	California	CA	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	8/4/2004	8/2/2004	Full-Time	1	10/30/2002	LOS ANGELE	EE CLAIMS: L LEG - VENUS THROMBOSIS WHILE WORKING IN LAS VEG	LAS VEGAS	89104	Nevada	NV	California	CA	Lost Time	LT	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2002	California Refom 0

Last rows

	Obs_ID	Dependent	Average Weekly Wage	Body Part	Body Part Code	Cause	Cause Code	Claimant Age	Claimant Atty Firm Name	Claimant Gender	Claimant Gender Code	Claimant Hire Date	Claimant Marital Status	Claimant Marital Status Code	Claimant State	Claimant State Code	Department Code	Detail Cause	Detail Cause Code	Domestic vs. Foreign?	Domestic vs. Foreign? Code	Dt Reported to Carrier/TPA	Dt Reported to Employer	Employment Status	Employment Status Code	Date of Injury/Illness	Handling Office Name	How Injury Occurred	Injury/Illness City	Injury/Illness Postal	Injury/Illness State	Injury/Illness State Code	Jurisdiction	Jurisdiction Code	Lost Time or Medical Only?	Lost Time or Medical Only? Code	Nature of Injury/Illness	Nature of Injury/Illness Code	Number of Dependents	OSHA Injury Type	OSHA Injury Type Code	Severity Index Code	Severity Index Code Code	Time of Injury/Illness	Type of Loss	Type of Loss Code	Policy Year	Reforms_dummy
15397	Obs_19459	264	NaN	Abdomen including Groin	61	Strain or Injury By	1500	38.0	NaN	Male	M	1/1/2014	NaN	NaN	Virginia	VA	18.0	Strain/Injury by Lifting	56	Domestic	D	10/20/2014	10/20/2014	Unknown/Other	7	10/20/2014	WC SOUTHEA	PATIENT WAS LIFTING LENS CASES, STATES SOMETHING DID NOT FEE	RICHMOND	23222	Virginia	VA	Virginia	VA	Medical Only	MO	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	830	Specific Injury	3.0	2014	NaN
15398	Obs_19460	1034	NaN	Brain	12	Struck or Injured By	1700	48.0	NaN	Male	M	7/21/2014	NaN	NaN	Florida	FL	20.0	Struck by Motor Vehicle	77	Domestic	D	10/20/2014	NaN	Unknown/Other	7	10/17/2014	WC SOUTHEA	EE WAS PERFORMING A STUNT WHEN HE GOT HIT BY A PICTURE CAR A	STONE MOUNTAIN	30087	Georgia	GA	Florida	FL	Medical Only	MO	Concussion	7	NaN	Injury	1.0	No Serious Injury Indicated	10.0	2230	Specific Injury	3.0	2014	NaN
15399	Obs_19461	926	NaN	Lower Leg	54	Cut, Puncture, Scrape Injured By	1200	60.0	NaN	Male	M	9/14/2014	NaN	NaN	Arizona	AZ	19.0	Cut/Puncture/Scrape, Object Lift/Handled	17	Domestic	D	10/21/2014	10/8/2014	Unknown/Other	7	10/3/2014	WC SOUTHEA	EE STATES WHILE MOVING STEEL HE LACERATED HIS R UPPER ASPECT	FAYETTEVILLE	30214	Georgia	GA	Georgia	GA	Medical Only	MO	Infection	36	NaN	Injury	1.0	No Serious Injury Indicated	10.0	1100	Specific Injury	3.0	2014	NaN
15400	Obs_19463	780	NaN	Shoulder(s)	38	Strain or Injury By	1500	39.0	NaN	Female	F	4/30/2014	NaN	NaN	Georgia	GA	8.0	Strain/Injury by Carrying	55	Domestic	D	10/22/2014	10/20/2014	Unknown/Other	7	10/20/2014	WC SOUTHEA	WHILE LOADING THE TRAILER EE FELT DISCOMFORT IN R SHOULDER.	SENOIA	30276	Georgia	GA	Georgia	GA	Medical Only	MO	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	1818	Specific Injury	3.0	2014	NaN
15401	Obs_19467	0	NaN	Hand	35	Cut, Puncture, Scrape Injured By	1200	44.0	NaN	Male	M	7/26/2014	NaN	NaN	North Carolina	NC	8.0	Cut/Puncture/Scrape, Hand Tool	16	Domestic	D	10/24/2014	10/24/2014	Unknown/Other	7	10/24/2014	WC SOUTHEA	EMPLOYEE WAS CUTTING ZIP TIES WITH A KNIFE WHEN IT SLIPPED O	WILMINGTON	28401	North Carolina	NC	North Carolina	NC	Medical Only	MO	Laceration	40	NaN	Injury	1.0	No Serious Injury Indicated	10.0	830	Specific Injury	3.0	2014	NaN
15402	Obs_19473	2405	NaN	Knee	53	Fall, Slip or Trip Injury	1300	21.0	NaN	Female	F	8/20/2014	NaN	NaN	Georgia	GA	6.0	Fall/Slip, Into Opening	28	Domestic	D	10/29/2014	10/29/2014	Unknown/Other	7	10/29/2014	WC SOUTHEA	EMPLOYEE WAS RETRIEVING PAINT SUPPLIES FROM A TRAILER WHEN S	FAYETTEVILLE	30214	Georgia	GA	Georgia	GA	Medical Only	MO	Inflammation	37	NaN	Injury	1.0	No Serious Injury Indicated	10.0	1115	Specific Injury	3.0	2014	NaN
15403	Obs_19475	1807	6,486.00	Shoulder(s)	38	Strain or Injury By	1500	33.0	NaN	Male	M	10/20/2014	NaN	NaN	Georgia	GA	20.0	Strain/Injury by Misc	60	Domestic	D	10/30/2014	10/30/2014	Full-Time	1	10/30/2014	WC SOUTHEA	PATIENT WAS IN A SCENE THAT REQUIRED HIM TO RUN, STOP AND FA	PEACHTREE CITY	NaN	Georgia	GA	Georgia	GA	Lost Time	LT	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	1558	Specific Injury	3.0	2014	NaN
15404	Obs_19489	0	NaN	Ankle	55	Strain or Injury By	1500	33.0	NaN	Male	M	1/1/2014	Unmarried, Single, Widowed, Divorced	U	Virginia	VA	22.0	Strain/Injury by Jumping	54	Domestic	D	11/6/2014	11/5/2014	Unknown/Other	7	11/5/2014	WC SOUTHEA	PATIENT JUMPED OVER A 4' WOODEN FENCE, LANDED ON UNEVEN GROU	HENRICO	23238	Virginia	VA	Virginia	VA	Medical Only	MO	Sprain	49	NaN	Injury	1.0	No Serious Injury Indicated	10.0	1900	Specific Injury	3.0	2014	NaN
15405	Obs_19501	507	NaN	Arm	33	Strain or Injury By	1500	34.0	NaN	Male	M	8/22/2014	NaN	NaN	Georgia	GA	3.0	Strain/Injury by Misc	60	Domestic	D	11/11/2014	11/10/2014	Unknown/Other	7	11/10/2014	WC SOUTHEA	PATIENT STATED HE WAS INJURED WHEN PLASTERING WALLS. PRODUCT	HIRAM	30141	Georgia	GA	Georgia	GA	Medical Only	MO	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	1041	Specific Injury	3.0	2014	NaN
15406	Obs_19510	0	NaN	Low Back Area	42	Strain or Injury By	1500	49.0	NaN	Female	F	10/6/2014	NaN	NaN	Missouri	MO	11.0	Strain/Injury by Twisting	53	Domestic	D	11/17/2014	11/17/2014	Unknown/Other	7	11/14/2014	WC SOUTHEA	WHILE PERFORMING REQUIRED JOB DUTIES, EE TWISTED HER BACK, A	NASHVILLE	37214	Tennessee	TN	South Carolina	SC	Medical Only	MO	Strain	52	NaN	Injury	1.0	No Serious Injury Indicated	10.0	1930	Specific Injury	3.0	2014	NaN

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows